Lesson: 14 - Basic operations in Spreadsheets

Purpose: Students learn formulae and basic operations in spreadsheets.

No. of. Classes

One class - One hour.

Materials Required

Desktop computer or Laptop & Open office.

Curriculum Content 7.4)Basic operations.
Prior knowledge

Students should know the concepts of four operations.


Students should know how to work in spreadsheets.

Exercises

Exercise:1


1. Adding, Subtracting, Multiplying and Dividing using spreadsheet operators.

Exercise:2


2. Create a new spreadsheet and name it as ‘student mark sheet.ods’.
Use formulae to calculate Total, Average and Pass / Fail result.

Solutions


  • Link to view the Solution Video for Exercise-1 (Solution).
  • Link to view the OpenOffice Solution Spreadsheets for Exercise-2 (Solution).

    • Teacher's Instructions
    1. Teachers should explain the importance of formulae in Spreadsheets.
    2. Teachers should ensure that the students understand simple operations like Addition, Subtraction, Multiplication, and Division.
    3. The students should know & the usage of the formula bar that is placed at the top left of the sheet.